1、如果数据库开启了flashback database需要禁用
alter database flashback off;
2、修改log_archive_dest_n参数,将其值修改为非fast recovery area
未修改之前:LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
(LOCATION=USE_DB_RECOVERY_FILE_DEST配置fast recovery area,该参数值为 DB_RECOVERY_FILE_DEST初始化参数指定的值)
修改为非FRA:ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/ORACLE/DBS/';
3、之后禁用fra初始化参数
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='';